<?php
 Zend_Loader::loadClass("CodesUtility"); 
 Zend_Loader::loadClass("BaseDBRow");
 class Country extends BaseDBRow
 {
	const _tablename = "projecte_ref.countries";
 	protected function setUp()
 	{
 		$this->_tableName = self::_tablename;		
 	}

	public function getCountryNames()
	{
		Zend_Loader::loadClass("QueryCreator");
		
		$query = new QueryCreator();
		$query->addSelect("c.country, c.country_code");
		$query->addFrom($this->_tableName . " as c ");
		
		$db = DBCon::instance();
		$result = $db->executeQuery($query->CreateSQL());
		return $result;
	}

 }
?>